---
title: SAIF.Application.Claim.Legal SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Documentation Pipeline
last_reviewed: 2026-08-21
library: SAIF.Application.Claim.Legal
reference_type: embedded
---

# SAIF.Application.Claim.Legal SQL catalog

This page indexes all 24 application-layer SQL statements and stored-procedure calls in this library, grouped by CRUD type. This library has no `IBusinessCriteria` implementations, so every `Business object` cell below is `N/A (Application layer)`; the calling `AppManager` class is noted in each statement's own document instead.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-insert-letter-request.md) | Insert a new legal letter request | Stored Proc | N/A — stored procedure | N/A (Application layer) |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](SQL-002-adjuster-list.md) | Retrieve claims adjuster code list | Inline | ADP_EMPLOYEE | N/A (Application layer) |
| [SQL-003](SQL-003-alj-list.md) | Retrieve administrative law judge (ALJ) list | Inline | LEGAL_PERSON, LEGAL_PERSON_TYPE | N/A (Application layer) |
| [SQL-004](SQL-004-attorney-list.md) | Retrieve attorney list with names | Inline | ADP_EMPLOYEE, ATTORNEY_PROFILE | N/A (Application layer) |
| [SQL-005](SQL-005-attorney-schedule-type-list.md) | Retrieve attorney schedule type codes | Inline | ATTORNEY_SCHEDULE_TYPE_CODE | N/A (Application layer) |
| [SQL-006](SQL-006-duration-code-list.md) | Retrieve hearing duration code list | Inline | DURATION_CODE | N/A (Application layer) |
| [SQL-007](SQL-007-location-code-list.md) | Retrieve hearing location code list | Inline | HEARING_LOCATION_CODE | N/A (Application layer) |
| [SQL-008](SQL-008-policy-name-list.md) | Retrieve distinct policy name list | Inline | POLICY | N/A (Application layer) |
| [SQL-009](SQL-009-attorney-assignment-table-list.md) | Retrieve attorney-assignment maintenance table list | Inline | LEGAL_CODE_TABLE | N/A (Application layer) |
| [SQL-010](SQL-010-duration-code-list-hearing-location.md) | Retrieve duration code list (hearing location screen) | Inline | DURATION_CODE | N/A (Application layer) |
| [SQL-011](SQL-011-location-code-list-hearing-location.md) | Retrieve hearing location code list (hearing location screen) | Inline | HEARING_LOCATION_CODE | N/A (Application layer) |
| [SQL-012](SQL-012-get-legal-case-header.md) | Retrieve legal case header by case number | Stored Proc | N/A — stored procedure | N/A (Application layer) |
| [SQL-013](SQL-013-firm-type-list.md) | Retrieve other-firm type code list | Inline | OTHER_FIRM_TYPE_CODE | N/A (Application layer) |
| [SQL-014](SQL-014-legal-view-code-list.md) | Retrieve legal code tables for person maintenance | Inline | LEGAL_CODE_TABLE | N/A (Application layer) |
| [SQL-015](SQL-015-person-type-list.md) | Retrieve legal person type code list | Inline | LEGAL_PERSON_TYPE_CODE | N/A (Application layer) |
| [SQL-016](SQL-016-other-parties-attorney-list.md) | Retrieve attorney firm list for other parties | Inline | OTHER_FIRM, DUAL | N/A (Application layer) |
| [SQL-017](SQL-017-other-parties-attorney-person-list.md) | Retrieve attorney person list for other parties | Inline | LEGAL_PERSON, LEGAL_PERSON_TYPE | N/A (Application layer) |
| [SQL-018](SQL-018-employer-type-list.md) | Retrieve employer/insurer firm list for other parties | Inline | OTHER_FIRM, DUAL | N/A (Application layer) |
| [SQL-019](SQL-019-appeal-num-level-list.md) | Retrieve appeal hearing level list by case | Inline | APPEAL, REVIEW_LEVEL_CODE, DUAL | N/A (Application layer) |
| [SQL-020](SQL-020-get-attorney-manager-email.md) | Retrieve assigned attorney's manager email address | Inline (scalar function) | DUAL | N/A (Application layer) |
| [SQL-021](SQL-021-get-legal-secretary-id.md) | Retrieve legal secretary employee ID by attorney | Inline | ATTORNEY_PROFILE | N/A (Application layer) |
| [SQL-022](SQL-022-update-case-attorney-list.md) | Retrieve attorney firm list for case update | Inline | OTHER_FIRM | N/A (Application layer) |
| [SQL-023](SQL-023-update-case-attorney-person-list.md) | Retrieve attorney person list for case update | Inline | LEGAL_PERSON, LEGAL_PERSON_TYPE | N/A (Application layer) |
| [SQL-024](SQL-024-case-status-list.md) | Retrieve case status codes by prior status | Inline | CASE_STATUS_CODE | N/A (Application layer) |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Application.Claim.Legal\clsAttorneyTableManager.vb`
- `SAIF.Application.Claim.Legal\clsHearingLocationManager.vb`
- `SAIF.Application.Claim.Legal\clsLegalPersonManager.vb`
- `SAIF.Application.Claim.Legal\clsLegalData.vb`
- `SAIF.Application.Claim.Legal\LegalManagerBase.vb`
- `SAIF.Application.Claim.Legal\LegalNet\clsOtherPartiesManager.vb`
- `SAIF.Application.Claim.Legal\LegalNet\clsOutcomeManager.vb`
- `SAIF.Application.Claim.Legal\LegalNet\clsUpdateCaseManager.vb`
- `SAIF.Application.Claim.Legal\LegalNet\clsSummaryManager.vb`
- `SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb`